<?php
/**
 * Application model for CakePHP.
 *
 * This file is application-wide model file. You can put all
 * application-wide model-related methods here.
 *
 * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 * @link          http://cakephp.org CakePHP(tm) Project
 * @package       app.Model
 * @since         CakePHP(tm) v 0.2.9
 * @license       http://www.opensource.org/licenses/mit-license.php MIT License
 */

App::uses('AppModel', 'Model');

/**
 * Application model for Cake.
 *
 * Add your application-wide methods in the class below, your models
 * will inherit them.
 *
 * @package       app.Model
 */
class Product extends AppModel  {

	public $useTable = 'product';
	public $name = 'Product';

	public function getNewProduct() {

		return $this->find('all', array('conditions' => array('delete_flg' => '0', 'status' => '1'), 'order' => 'id DESC'));
	}

	public function getProductByCategoryId($id) {
		return $this->find('all', array('conditions' => array('delete_flg' => '0', 'category_id' => $id), 'order' => 'id DESC'));
	}

	public function getSpecialProduct($flag) {

		if($flag == 1)
			return $this->find('all', array('conditions' => array('delete_flg' => '0', 'special' => '1'), 'order' => 'id DESC'));
		else
			return $this->find('first', array('conditions' => array('delete_flg' => '0', 'special' => '1'), 'order' => 'id DESC'));
	}

	public function getMostViewProduct($flag) {

		if($flag == 1)
			return $this->find('all', array('conditions' => array('delete_flg' => '0'), 'order' => 'view DESC'));
		else
			return $this->find('first', array('conditions' => array('delete_flg' => '0'), 'order' =>'view DESC'));
	}

	public function getSaleOffProduct($flag) {

		if($flag == 1)
			return $this->find('all', array('conditions' => array('delete_flg' => '0', 'sale_off >' => '0'), 'order' => 'view DESC'));
		else
			return $this->find('first', array('conditions' => array('delete_flg' => '0'), 'order' =>'view DESC'));
	}

	public function getProductDetail($id) {

		return $this->find('first', array('conditions' => array('delete_flg' => '0', 'id' => $id)));
	}

	public function updateView($id) {

		$detail = $this->getProductDetail($id);
		
		$this->create();
		$this->id = $id;
		$this->save(array('view' => $detail['Product']['view'] + 1));
	}
}
